package com.example.mapper;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/*
 *  @author 雨安
 *  类名： ObjMapper
 *  创建时间：2024/5/24
 */
@Repository
public interface ObjMapper {

    /**
     * 该Mapper作用清空昨天从运政取出来的数据
     */

    @Select("truncate table heavygeneralcargo")
    public void deleteHeaAll();

    @Select("truncate table householdinformation")
    public void deleteHouseAll();

    @Select("truncate table occupationalrequirements")
    public void deleteOccAll();

    @Select("truncate table roadtransport")
    public void deleteTranAll();

    @Select("truncate table roadtransportvehicles")
    public void deleteRoadAll();

    @Select("truncate table practitioner")
    public void deletePraAll();

    @Select("truncate table businessoperation")
    public void deleteBusAll();





    @Select("select count(*) from  heavygeneralcargo")
    public Integer selectHeaAll();

    @Select("select count(*) from householdinformation")
    public Integer selectHouseAll();

    @Select("select count(*) from occupationalrequirements")
    public Integer selectOccAll();

    @Select("select count(*) from roadtransport")
    public Integer selectTranAll();

    @Select("select count(*) from roadtransportvehicles")
    public Integer selectRoadAll();

    @Select("select count(*) from practitioner")
    public Integer selectPraAll();

    @Select("select count(*) from businessoperation")
    public Integer selectBusAll();

}
